You are here: 2. General Ledger > 2.1. Introduction to Micronet General Ledger > 2.1.4. Accounting for Specific Micronet Transactions > MDS Accounting Stock and Purchasing

MDS Accounting - Stock and Purchasing

Accounting for Stock and Purchasing within the Micronet Distribution System is based upon the cost or management style ledger where individual standard costs are applied and purchase price variances are calculated and taken up (as seen in the example in the last topic). In the valuation of stock, Micronet generally uses average cost as the standard cost. Where FIFO (First in First Out) or LIFO (Last in Last Out) stock valuation is being applied, Micronet generally assumes actual cost.

These two methods of stock valuation are generally used only where serial numbers or unique identification of products occurs, and thus costs can be tracked more individually. In most cases, average cost is applied where stock items are received in lump sum volumes and items are generic in nature. This creates greater efficiency and speeds up the data entry process, especially where high volume stock receiving is evident within a business operation.

Traditionally, stock and Cost of Sales are accounted for in a very manual way in the ordinary General Ledger. For example:

Balance Sheet    
Current Assets    
Stock on Hand $152,635.00  
Profit & Loss Statement    
Cost of Sales    
Opening Stock $132,987.00  
Add: Purchases $558,698.00 $691,685.00
Less: Closing Stock $152,635.00
Total Cost of Sales $539,050.00  

In the above example, we are effectively trying to estimate the value of the cost of the products we have sold within a specified period. We are calculating our estimation in bulk or total amounts and the cost reflected is based on actual amounts paid. This system is very effective for manual stock systems and controls. However, Micronet is capable of calculating the cost of each product sold at the time of sale: perpetual stock method. Therefore, the traditional method of accounting for stock and Cost of Sales as shown above is unnecessary.

Micronet reports perpetual stock and Cost of Sales in the following way, where average cost is applied as the standard cost to products and items within the Distribution system:

Balance Sheet $ $
     
Inventory    
Stock on Hand   152,635.00
Goods Received -563,258.00  
Goods Received Adjustments 3,987.00  
Purchases 558,698.00 -573.00
     
Total Inventory   152,062.00

 

Profit & Loss Statement $ $
     
Cost of Sales    
Cost of Sales (MDS)   $532,987.00
     
Cost of Sales Adjustments    
Stock Adjustments 5,563.00  
Stocktake Adjustments 2,698.00  
File Cost Changes -856.00  
Revalue Stock Sold -4,250.00  
Uncosted Reconciliation 852.00  
Supplier Rebate COS Adjustment 5,456.00  
     
Total Cost of Sales Adjustments   9,463.00
     
Net Cost of Sales   542,450.00

 

While Micronet stock and Cost of Sales accounting appears to be far more sophisticated than traditional methods of inventory and cost valuations, the classifications shown above all have a specific purpose. Each captures a diverse and unique type of transaction occurring in the application and process of average cost as the standard for inventory valuation.